/* rcbr004.p - Customer Order Periods Browse UI                             */
/* Copyright 1986-2002 QAD Inc., Carpinteria, CA, USA.                      */
/* All rights reserved worldwide.  This is an unpublished work.             */
/* $Revision: 1.10 $    */
/*V8:ConvertMode=NoConvert                                                  */
/********************************** History *********************************
 *    Revision: 8.5      Created: 06/19/97    By: B. Pedersen    *J1TF*
 *    Revision: 8.5     Modified: 07/17/97    By: Jean Miller    *J1WZ*
 *    Revision: 8.5     Modified: 09/26/97    By: B. Pedersen    *J20C*
 *    Revision: 8.5     Modified: 01/31/99    By: Doug Norton    *M071*
 *    Revision: 9.0     Modified: 03/15/99    By: Mark Smith     *M0BF*
 *    Revision: 9.1     Modified: 08/15/00    By: Mark Brown     *N0KP*
 * $Revision: 1.10 $    BY: Jean Miller          DATE: 04/05/02  ECO: *P044*
 ****************************************************************************/

{mfdeclre.i}

&SCOPED-DEFINE BR-TITLE "Customer Order Periods"

&SCOPED-DEFINE BR-NAME rc004
&SCOPED-DEFINE Q-DRAG-BACK-COL 1

&SCOPED-DEFINE Q-FIRST-TABLE cpcd_det
&SCOPED-DEFINE Q-FIRST-FIELD-LIST (cpcd_cust cpcd_year cpcd_type cpcd_per cpcd_start cpcd_end)
&SCOPED-DEFINE Q-2ND-TABLE ad_mstr
&SCOPED-DEFINE Q-2ND-JOIN ad_addr = cpcd_cust
&SCOPED-DEFINE Q-2ND-FIELD-LIST (ad_name)
&SCOPED-DEFINE Q-NUM-TABLES 2

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-1 b-1.cpcd_cust
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-1 cpcd_det.cpcd_cust
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-1 tt-cpcd_cust
&SCOPED-DEFINE BR-K-COL-LABEL-1 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-1 "Customer"
&SCOPED-DEFINE BR-FIELD-TYPE-1 character
&SCOPED-DEFINE BR-FIELD-FRMT-1 FORMAT "x(8)"
&SCOPED-DEFINE BR-FIELD-WIDTH-1 9

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-2 b-1.cpcd_year
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-2 cpcd_det.cpcd_year
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-2 tt-cpcd_year
&SCOPED-DEFINE BR-K-COL-LABEL-2 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-2 "Year"
&SCOPED-DEFINE BR-FIELD-TYPE-2 integer
&SCOPED-DEFINE BR-FIELD-FRMT-2 FORMAT "9999"
&SCOPED-DEFINE BR-FIELD-WIDTH-2 5

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-3 b-1.cpcd_type
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-3 cpcd_det.cpcd_type
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-3 tt-cpcd_type
&SCOPED-DEFINE BR-K-COL-LABEL-3 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-3 "Type"
&SCOPED-DEFINE BR-FIELD-TYPE-3 character
&SCOPED-DEFINE BR-FIELD-FRMT-3 FORMAT "x(1)"
&SCOPED-DEFINE BR-FIELD-WIDTH-3 5

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-4 b-1.cpcd_per
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-4 cpcd_det.cpcd_per
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-4 tt-cpcd_per
&SCOPED-DEFINE BR-K-COL-LABEL-4 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-4 "Period"
&SCOPED-DEFINE BR-FIELD-TYPE-4 integer
&SCOPED-DEFINE BR-FIELD-FRMT-4 FORMAT ">>9"
&SCOPED-DEFINE BR-FIELD-WIDTH-4 7

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-5 b-1.cpcd_start
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-5 cpcd_det.cpcd_start
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-5 tt-cpcd_start
&SCOPED-DEFINE BR-K-COL-LABEL-5 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-5 "Start"
&SCOPED-DEFINE BR-FIELD-TYPE-5 date
&SCOPED-DEFINE BR-FIELD-FRMT-5 FORMAT "99/99/99"
&SCOPED-DEFINE BR-FIELD-WIDTH-5 9

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-6 b-1.cpcd_end
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-6 cpcd_det.cpcd_end
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-6 tt-cpcd_end
&SCOPED-DEFINE BR-K-COL-LABEL-6 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-6 "Expire"
&SCOPED-DEFINE BR-FIELD-TYPE-6 date
&SCOPED-DEFINE BR-FIELD-FRMT-6 FORMAT "99/99/99"
&SCOPED-DEFINE BR-FIELD-WIDTH-6 9

&SCOPED-DEFINE Q-BROWSE-DISP-EXPR-7 b-2.ad_name
&SCOPED-DEFINE Q-BROWSE-DEF-EXPR-7 ad_mstr.ad_name
&SCOPED-DEFINE TT-Q-BROWSE-DEF-EXPR-7 tt-ad_name
&SCOPED-DEFINE BR-K-COL-LABEL-7 COLUMN-LABEL
&SCOPED-DEFINE BR-COLUMN-LABEL-7 "Name"
&SCOPED-DEFINE BR-FIELD-TYPE-7 character
&SCOPED-DEFINE BR-FIELD-FRMT-7 FORMAT "x(28)"
&SCOPED-DEFINE BR-FIELD-WIDTH-7 29

&SCOPED-DEFINE Q-NUM-FILT-VALS 7
&SCOPED-DEFINE BR-MAX-FIELD-WIDTH 29
&SCOPED-DEFINE BR-BROWSE-WIDTH 73
&SCOPED-DEFINE WHERE-CLAUSE
&SCOPED-DEFINE BR-INDEXED-FIELDS 1

{wbbr01.i}
if c-application-mode <> 'WEB' then do:
   {browse.i}
end.
